package com.simtop.hj.mapper;

import com.simtop.hj.pojo.*;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.data.repository.query.Param;

import java.util.List;

@Mapper
public interface UserMapper {
    User login(User user);

    List<Role> getRole();

    int register(User user);

    User checkEmail(@Param("email") String email);

    int updatePassword(User user);

    void expertLogin(User expertLoginUser);


    List<User> searchUser(@Param("username") String username,@Param("subjects") String subjects,@Param("loginName") String loginName,@Param("studyYear")String studyYear);

    int deleteUser(@Param("id") Integer id);


    void deleteVisitorRole();

    Integer getUserNums();

    List<HJPP> getHJPP();

    List<DSHJ> getDSHJ();

    List<WBHJ> getWBHJ();

    List<WineWorld> getIndexData();

    void createReportCart(Grade grade);

    Integer addComment(Grade grade);


    List<Grade> getGrade(User user);


    Integer getExperiment();

    Echarts3 selectScoreUser();

    List<String> getContentParticiple();

    String getCx(@Param("i") int i);

    User checkUsername(User user);

    int updateUser(User user);

    int addUser(User user);

    List<DownGrade> downLoadGrade(User user);

    int deleteGrade(@Param("gradeId") Integer gradeId);

    int addScore(Grade grade);
}
